/*
 Navicat Premium Data Transfer

 Source Server         : 47.111.170.225
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : 47.111.170.225
 Source Database       : config_center

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : utf-8

 Date: 06/09/2020 11:11:23 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `sys_param`
-- ----------------------------
DROP TABLE IF EXISTS `sys_param`;
CREATE TABLE `sys_param` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pkey` varchar(255) COLLATE utf8_bin NOT NULL,
  `pvalue` varchar(255) COLLATE utf8_bin NOT NULL,
  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `sys_param`
-- ----------------------------
BEGIN;
INSERT INTO `sys_param` VALUES ('1', 'wxe2cc8190ee1a2d95', '3008c6dea67410dfa04a2398aaf47108', 'cgj');
COMMIT;

-- ----------------------------
--  Table structure for `wx_oa_access_token`
-- ----------------------------
DROP TABLE IF EXISTS `wx_oa_access_token`;
CREATE TABLE `wx_oa_access_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `appsecret` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `access_token` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `js_api_ticket` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `access_token_expire` datetime DEFAULT NULL,
  `js_api_ticket_expire` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_appid` (`appid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `wx_oa_access_token`
-- ----------------------------
BEGIN;
INSERT INTO `wx_oa_access_token` VALUES ('1', 'wxe2cc8190ee1a2d95', '3008c6dea67410dfa04a2398aaf47108', '34_Op9GLOUQNWmNgo08HpiuzLDyzmR1a7QnqTOp5LLYs7EFf3UVto2gL6sulXhXvdqyfvbEpnad9qYEal2Y4jkH47VcNjfe0RIE-NkLBxueieQKRVfnlUbeL5FQbdSpbdAnmDTAdD5ifl3bkewTTYUfACALQM', 'kgt8ON7yVITDhtdwci0qeaanEQ21v4rwLMJfi8edVD_KD-Sh5HWYRuaV7PW7vmgSjz-AjqSr9ZhUZo49BrETcQ', '2020-06-09 12:14:40', '2020-06-09 12:17:10'), ('2', 'wx5da2939b7b0970bb', 'e1616afa01c47435231aadb9c675ada3', '34_m432r-LL9y1W7vXe4oWT-1m7qMuJFSfEMcZfJy4gqWCwabejFeqm-Zr2dwu71KQD25CNKszmjtry86j-LyyBg9bt7LPq0BFs8EcuAFbqWbm0d1g7BFyv-gvEdF_gblSAxc5NRtYQAzMd-9GcAEUjAIAQUK', 'kgt8ON7yVITDhtdwci0qeag6Xdt2aRLI26Z-Np6ycedkH_kqXpmaen7GFpQ-6zwOTswgvgaXM9Jgqdr3kWpJNw', '2020-06-09 11:26:10', '2020-06-09 11:26:10'), ('3', 'wx5d2e5b1d2d96513b', 'a0f480266d764a9c25d7709253b1362e', '34_03brP-kg8vVYRHkk429vZHWD1AHY_ozHexjVqqcQsi5DYeDZdzeYjcas4sJv7L3QLPMF0DC5t_jwTgseYKUV8zrD6DxqaYKuGHjoWs2I6nzHWaEUbqotHfjnGisqxaPVeEhy2vuUDem6a3ziAPQhAIAMBC', 'HoagFKDcsGMVCIY2vOjf9kc_enqa8vr2gIkdT3OQJv_2iB11RjJ_Tp3JxEtOX6fA_24kw6IMlqJHcSZ9Xsr-lQ', '2020-06-09 11:50:10', '2020-06-09 11:50:10');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
